UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VxXEn6yKBJtBsAnxTjLTpKMjhZWDvM/hngA0XwBwnGw='
WHERE
key_id = '47a2896338d734080dde4922ed07575df1bd11158dc2a3820923fbb615bf0582'
AND (
token = 'VxXEn6yKBJtBsAnxTjLTpKMjhZWDvM/hngA0XwBwnGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)