UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sh0COkFSpSHvi5fVtAoBSl/h+rrnI2MPGRErCBtSggw='
WHERE
key_id = '1cd12d1a20beefadacc7a741bc83453f0460fad62a8a4a7f6fcf17739f05a567'
AND (
token = 'Sh0COkFSpSHvi5fVtAoBSl/h+rrnI2MPGRErCBtSggw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)