UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0BzVajC9U8AvXjIBAvHyi5/E8ZBxLHPRRDzqpFI3hL8='
WHERE
key_id = '8c9a924e9ca7d28f5713d00ccbfb34b55219b41545e43a6ed4751640a59823bb'
AND (
token = '0BzVajC9U8AvXjIBAvHyi5/E8ZBxLHPRRDzqpFI3hL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)