UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ZOjE2k4b/I6xXUcWjzAzmg3Ap5affO9kwigZacMTe4='
WHERE
key_id = 'f5790a3aef39c5e487350530bf1159e30cb5e2bc00f518b7224e0f8c6f4e7019'
AND (
token = '2ZOjE2k4b/I6xXUcWjzAzmg3Ap5affO9kwigZacMTe4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)