UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QB2M1n3Q0Hl6y8bYrJaLfQv5WXMHjnnbsCx9tI13MI8='
WHERE
key_id = '10bead6b69101438bb143a0db9839d00f28095fdf66697521554c8f2f4692e8a'
AND (
token = 'QB2M1n3Q0Hl6y8bYrJaLfQv5WXMHjnnbsCx9tI13MI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)