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