UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BGq+6tx+g8SscgA+n7A+MlrNmrNHSSZw4mmTyQxzPHk='
WHERE
key_id = 'dbb9ac2572170e7ae59b57a1233c49b1180d07463ac4241624fa7f5de0ec0dd2'
AND (
token = 'BGq+6tx+g8SscgA+n7A+MlrNmrNHSSZw4mmTyQxzPHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)