UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JsBUskuYN038WcfH1McMTjuKZm9P6Tnn8WgW48lnIow='
WHERE
key_id = '8ca4989fb40fcdae2b9ea6eb33f52636b75f2e2a27a5c899952dbfbb675d3ae6'
AND (
token = 'JsBUskuYN038WcfH1McMTjuKZm9P6Tnn8WgW48lnIow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)