UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XbPf/rcf0C06JfhrQHowk3EOfoLjxWVPk4yueeMljRQ='
WHERE
key_id = '6e4972f3af56a0701fc161c1b0abc250c3f71ea88524e2b21ab7804ee42b2818'
AND (
token = 'XbPf/rcf0C06JfhrQHowk3EOfoLjxWVPk4yueeMljRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)