UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OAAeoXvJoMgE1l942jkGPreSH1pmMaMR/qMsnIYfh8Y='
WHERE
key_id = 'c1b733b056bc4d09e5d7b8b0a18d5aacd9c71c0bd226fb5f08d307d9a5ac6557'
AND (
token = 'OAAeoXvJoMgE1l942jkGPreSH1pmMaMR/qMsnIYfh8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)