UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zeb5nlRdepAx8DFZ+IwJThX0+YGpd11ieAzCUEp7/Kw='
WHERE
key_id = 'd6ae24f9a1d2ba528975b127433d82c96a503243817397e4b2a787143a902f47'
AND (
token = 'zeb5nlRdepAx8DFZ+IwJThX0+YGpd11ieAzCUEp7/Kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)