UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DtAsDV7gfDFTiP4wOwDWqvY6ebHvT8dnYB/N0QDIDHs='
WHERE
key_id = 'f8ebcf308adcdf96cc11550f3ce938184ecf83921b20224fe22baaf144947023'
AND (
token = 'DtAsDV7gfDFTiP4wOwDWqvY6ebHvT8dnYB/N0QDIDHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)