UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jidN0wtLZnJlI9OCdqASVIBK6ougYkH8AhG3YaU1hDE='
WHERE
key_id = 'ac43f946f8410ae6788fe7fda91dc5c648fea724a353e9cb18989945a351d417'
AND (
token = 'jidN0wtLZnJlI9OCdqASVIBK6ougYkH8AhG3YaU1hDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)