UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qJnSTBHKHzhSpC0ERZ8Z6t9U1ZY5O8Zm47VMDlILuD8='
WHERE
key_id = 'd605d217535f239df667f3f32d13eb0ab226a91f662aea9b785d89f9a08764a9'
AND (
token = 'qJnSTBHKHzhSpC0ERZ8Z6t9U1ZY5O8Zm47VMDlILuD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)