UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ztUeZ1i8p8aAVkCzhkaFJyD2w1Rrzfm9SC/x01+bvFg='
WHERE
key_id = 'db45e29832380f622199239671b3f01956d263357ac4dd9177dcc066893ac848'
AND (
token = 'ztUeZ1i8p8aAVkCzhkaFJyD2w1Rrzfm9SC/x01+bvFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)