UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ui163M0nSuUlypH+kA+0jj2L8V1iFkUpyhpaz0b6GVE='
WHERE
key_id = 'a06c4d21531592541aa81672cecc2e22e2d3d0b8f65d80a6768937e7206938c5'
AND (
token = 'ui163M0nSuUlypH+kA+0jj2L8V1iFkUpyhpaz0b6GVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)