UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z/crcg7Xo2uEWLWXTawlWhgHY3bERDu2iojFpkrhOeA='
WHERE
key_id = '1c0367fbfc0e7ceac65f7f1e0f9398963b8e830f758abde78d11ccdbe622b7a0'
AND (
token = 'Z/crcg7Xo2uEWLWXTawlWhgHY3bERDu2iojFpkrhOeA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)