UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9cXZMo7ZupX1jkXtwT3AKbFsunv2Et8MntxM6qD0uZ0='
WHERE
key_id = '20122231ec69447b0b3ef8a801bc2115dc7495df47729f4193581bcf1dc12443'
AND (
token = '9cXZMo7ZupX1jkXtwT3AKbFsunv2Et8MntxM6qD0uZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)