UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BF3xHbC17GBEk23kZlnud3Ue1eCP/s+jygFtHCS+irE='
WHERE
key_id = 'ea71b518204999c980bd527048eccc35a55cf90deebbd8885600a199d76261a4'
AND (
token = 'BF3xHbC17GBEk23kZlnud3Ue1eCP/s+jygFtHCS+irE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)