UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JfWK2Xr9Umu2pXF9vLQhjwlVspjc4Ox1fgVrUqHnrRw='
WHERE
key_id = '478fcc6b229dec96792d78864961bafdc907d6330e4bca56020a17986a7dffb7'
AND (
token = 'JfWK2Xr9Umu2pXF9vLQhjwlVspjc4Ox1fgVrUqHnrRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)