UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '59PX0kSLfD2HFxWNNIm+7INnAuBRcQfZgBpIFmnmadA='
WHERE
key_id = 'a9369a913fe65dfc4167bfddf9c30a85f20c84ad79c9b77fae147b09fcb26b7e'
AND (
token = '59PX0kSLfD2HFxWNNIm+7INnAuBRcQfZgBpIFmnmadA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)