UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bml2ZCNOfetVX+6gCUtFSdk+lpSgL9wukSD6yXHw5tc='
WHERE
key_id = '77af8027d5d596a7a1886e1e4a3ef3e0173a7d289544864c5e19cb4baaea06f4'
AND (
token = 'Bml2ZCNOfetVX+6gCUtFSdk+lpSgL9wukSD6yXHw5tc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)