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