UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XU5BirIz/QkN7bTdPiDfsdk/tVCZj5Of9hhZtS40JFU='
WHERE
key_id = '3eacf9a457cf9456318b45b086854c8d05a27018302f3c099e29ea988c0cdfd5'
AND (
token = 'XU5BirIz/QkN7bTdPiDfsdk/tVCZj5Of9hhZtS40JFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)