UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R7Z48uB9Xct1gzRp8vG66KDrCD05tnop2cM8i3sp7nI='
WHERE
key_id = '0ffa985aa804c7a19c667a109663253eee928de8380b6026aa418bfffa61aac0'
AND (
token = 'R7Z48uB9Xct1gzRp8vG66KDrCD05tnop2cM8i3sp7nI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)