UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ZQcJoXFB7KoRAt8OvgoonFyKGYMV4KSB+S1genu27o='
WHERE
key_id = 'bcb7b5a044f569373f7e47bd224e60a3bde8be7f15bd953c9afb9989f2583ecc'
AND (
token = '8ZQcJoXFB7KoRAt8OvgoonFyKGYMV4KSB+S1genu27o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)