UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ifn1giCOAYyQQJXf/6ONFWSuU9e3qrsSot3C1uGlF0g='
WHERE
key_id = 'ae27c8a1d917d469e63d12e2cc94747918adcfc53f6d103c344bbd9eaad649c9'
AND (
token = 'Ifn1giCOAYyQQJXf/6ONFWSuU9e3qrsSot3C1uGlF0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)