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