UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bvgzJj6Bd1d46zvyXXw1+dtB0zNTbU0/pyo9TRVjsA8='
WHERE
key_id = '1ef9e531416607cc224c517ac6bee3380a5102f8d48e2914c0a0a883b9a47bf1'
AND (
token = 'bvgzJj6Bd1d46zvyXXw1+dtB0zNTbU0/pyo9TRVjsA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)