UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xr6UqmsFQNX6RfUw6VGZ8oTspqKIMhxNhWUDv13wHp8='
WHERE
key_id = '08a1c9b2cb0ed48088b4d22f3233e603a560d1304c9aee91b26c666c6e4a6402'
AND (
token = 'xr6UqmsFQNX6RfUw6VGZ8oTspqKIMhxNhWUDv13wHp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)