UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B6WJFsVvngeaXdBXBsYTdY1fG0PLo8wZ4RlRAIiycgc='
WHERE
key_id = '6deb1272c8400e9390d09431c6563bb130e47973b6e2f06f6d4bd8400b8d4004'
AND (
token = 'B6WJFsVvngeaXdBXBsYTdY1fG0PLo8wZ4RlRAIiycgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)