UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '636EIEHRK3opvAfqkH2IPJc9tnrDyiF6adYFob6sP2M='
WHERE
key_id = 'bf8c9c1744fb50cee2a7e3dbe2d8babc97f3c0238c63720ac8d1f5ebe15d9220'
AND (
token = '636EIEHRK3opvAfqkH2IPJc9tnrDyiF6adYFob6sP2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)